<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>COMMENT HANDLER LIKE</title>
</head>

<body>
	<?php
		$UserID = $_GET['UserID'];
		$CommentID = $_GET['CommentID'];
		
		@ $db = mysql_pconnect("localhost","root","");
			
		if(!$db)
		{
			echo "<h2>Database does not exist!</h2>";
			exit;
		}
			
		mysql_set_charset('UTF8');
		mysql_select_db('Studial');
		
		$now = getdate();
		
		$selectNumliked = "SELECT numliked FROM `comments` WHERE user_id = '".$UserID."' AND id = ".$CommentID."'";
		$resultNumliked = mysql_query($selectNumliked) + 1;
		
		$updateNumliked = "UPDATE `studial`.`comments` SET `numliked` = ".$resultNumliked."' WHERE user_id = ".$UserID."' AND id = ".$CommentID."'";
		$queryNumliked = mysql_query($updateNumliked);
		
		$insertLike = "INSERT INTO `studial`.`like` (`user_id`, `comment_id`, `type`, `dateliked`) VALUES ('".$UserID."', '".$CommentID."', 0, '".$now."')";
		$queryLike = mysql_query($insertLike);
		
		header("location: ../studial/users/homeboard.php");
	?>
</body>
</html>